SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (assigned_to = 'Pilkington Brothers Limited') ORDER BY last_name ASC, first_name, date, patent, type |
Total of 2 patents found where: Assigned To is 'Pilkington Brothers Limited';
View a patent by clicking on the patent number. You can sort by any of the columns by clicking on the column name.
T / S | Patent | Date | Description | Patentee | Category | Assigned To |
EDWARDS, Derrik R. | ||||||
U | 3,141,063 | July 14, 1964 | Toughened Glass, Pin Type Insulator Glass tempering method |
EDWARDS, Derrik R. |
Glass | Pilkington Brothers Limited |
JELLYMAN, Philip E. | ||||||
U | 2,870,244 | January 20, 1959 | Glass Insulator Assembly Units Glass toughened by stream of air after forming |
JELLYMAN, Philip E. |
Glass | Pilkington Brothers Limited |
Total of 0.01 seconds